Data Warehouse Analyst

The Executive Office of Health and Human Services (EOHHS) oversee expenditures of over $28 billion annually. As the largest secretariat, has approximately 22,000 employees and services almost 2 million people, one in three residents of the Commonwealth. The mission of EOHHS is to provide effective leadership and management in the development and provision of health and human services that promote health and safety, independence, and quality of life for individuals and families, and communities throughout the Commonwealth of Massachusetts. To know more about EOHHS, please visit\: Executive Office of Health and Human Services

About the Team\:

The MassHealth Enterprise Data Management and Engineer Team (EDME) support MassHealth organizational data exchange, storage, transformation, access, query, technology, and reporting needs. The EDME teams include Business Analytics, Operations, Data Quality, Data Informatics, Federal Reporting, Business Intelligence, and Project Management Office. In addition to maintaining data applications, services, technologies, and infrastructure; the EDME partners with the Data Integrity, Data Strategy, and MassHealth Analytics teams to manage new and existing project portfolio requests received from MassHealth business teams through a formalized Intake, Governance, and Prioritization process.

About the Role\:

The Data Warehouse Analyst will support existing warehouse analytics and provide input on best practices and potential efficiencies, work on multiple assignments concurrently to meet aggressive due dates, uses a range of expert technical skills based on a keen knowledge of data warehouse concepts, and must be highly proficient with Snowflake SQL.  This resource needs to have extensive experience querying tables and views to develop, enhance, and update new and existing reports.  The Data Warehouse Analyst will also be responsible for the development of data visualizations using contemporary business intelligence (BI) tools like Tableau, Cognos, Snowflake, and/or SAS.

The primary work location for this role will be at 1 Enterprise Drive, Quincy MA, 02171.  The work schedule for this position is Monday through Friday, 9\:00AM-5\:00PM EST. This position is expected to follow a hybrid work model that combines in-office and remote work as needed.

Duties and Responsibilities\:

• Develop and maintain reports, data visualizations, and ad-hoc data extracts using Tableau Server.

• Perform ETL development and manage data exchange processes within AWS platforms, including identifying process gaps and recommending improvements.

• Validate the accuracy and completeness of data extracts and reports.

• Interact on a professional basis with internal and external staff in a personable manner

• Develop reports for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purpose as requested.

• Support on-going development of cost, utilization and other reporting metrics, including collaboration with business program managers for MCO, HIX, and MMIS source data

• Communicate business requirements to Cognos and Snowflake developers and work with them to implement solutions for the business community.

• Communicate progress, or impediments to progress, to users and managers.

• Recode existing macro-based code, including remediation as approved

• Review technical documents and test plans, test results and coordinate implementation activities with end-users and EDME staff

• Organize and manage workload independently with minimal supervision while contributing to team projects and meetings.

• Analyze data extract processes, identify gaps, recommend improvements, and validate the accuracy of reports and data extracts.

Preferred Experience, Knowledge and Skills\:

• Two (2) to five (5) years of experience supporting and maintaining data warehouse environments.
• Demonstrated proficiency in SQL and experience with data analysis tools such as Snowflake, SAS, and Tableau.
• Ability to gather and evaluate business requirements, manage requests from diverse business users, and develop effective solutions.
• Experience producing standard and ad-hoc reports, performing advanced data mining, and generating accurate queries and outputs under tight deadlines.
• Ability to understand business requirements and regulatory needs and assess their impact on business operations and EDME.
• Experience maintaining comprehensive code documentation and developing business and system documentation in accordance with EOHHS standards and policies.
• Strong initiative and problem-solving skills, with the ability to independently research issues, identify solutions, and improve processes.
• Ability to quickly learn new technologies, tools, systems, data sources, and business processes with minimal guidance.
• Ability to manage competing priorities, adapt to changing demands, and meet deadlines in a fast-paced environment.

Pre-Offer Process\:

A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit http\://www.mass.gov/hhs/cori.

Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines.

Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the Commonwealth’s website.

ADA Reasonable Accommodation\: If you require a reasonable accommodation with the application/interview process, please contact us at\: EOHHS Candidate ADA Requests

For questions, please the contact the Office of Human Resources at 1-800-510-4122 and select option #4.

The Executive Office of Health and Human Services (EOHHS) oversee expenditures of over $28 billion annually. As the largest secretariat, has approximately 22,000 employees and services almost 2 million people, one in three residents of the Commonwealth. The mission of EOHHS is to provide effective leadership and management in the development and provision of health and human services that promote health and safety, independence, and quality of life for individuals and families, and communities throughout the Commonwealth of Massachusetts. To know more about EOHHS, please visit\: Executive Office of Health and Human Services

About the Team\:

The MassHealth Enterprise Data Management and Engineer Team (EDME) support MassHealth organizational data exchange, storage, transformation, access, query, technology, and reporting needs. The EDME teams include Business Analytics, Operations, Data Quality, Data Informatics, Federal Reporting, Business Intelligence, and Project Management Office. In addition to maintaining data applications, services, technologies, and infrastructure; the EDME partners with the Data Integrity, Data Strategy, and MassHealth Analytics teams to manage new and existing project portfolio requests received from MassHealth business teams through a formalized Intake, Governance, and Prioritization process.

About the Role\:

The Data Warehouse Analyst will support existing warehouse analytics and provide input on best practices and potential efficiencies, work on multiple assignments concurrently to meet aggressive due dates, uses a range of expert technical skills based on a keen knowledge of data warehouse concepts, and must be highly proficient with Snowflake SQL.  This resource needs to have extensive experience querying tables and views to develop, enhance, and update new and existing reports.  The Data Warehouse Analyst will also be responsible for the development of data visualizations using contemporary business intelligence (BI) tools like Tableau, Cognos, Snowflake, and/or SAS.

The primary work location for this role will be at 1 Enterprise Drive, Quincy MA, 02171.  The work schedule for this position is Monday through Friday, 9\:00AM-5\:00PM EST. This position is expected to follow a hybrid work model that combines in-office and remote work as needed.

Duties and Responsibilities\:

• Develop and maintain reports, data visualizations, and ad-hoc data extracts using Tableau Server.

• Perform ETL development and manage data exchange processes within AWS platforms, including identifying process gaps and recommending improvements.

• Validate the accuracy and completeness of data extracts and reports.

• Interact on a professional basis with internal and external staff in a personable manner

• Develop reports for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purpose as requested.

• Support on-going development of cost, utilization and other reporting metrics, including collaboration with business program managers for MCO, HIX, and MMIS source data

• Communicate business requirements to Cognos and Snowflake developers and work with them to implement solutions for the business community.

• Communicate progress, or impediments to progress, to users and managers.

• Recode existing macro-based code, including remediation as approved

• Review technical documents and test plans, test results and coordinate implementation activities with end-users and EDME staff

• Organize and manage workload independently with minimal supervision while contributing to team projects and meetings.

• Analyze data extract processes, identify gaps, recommend improvements, and validate the accuracy of reports and data extracts.

Preferred Experience, Knowledge and Skills\:

• Two (2) to five (5) years of experience supporting and maintaining data warehouse environments.
• Demonstrated proficiency in SQL and experience with data analysis tools such as Snowflake, SAS, and Tableau.
• Ability to gather and evaluate business requirements, manage requests from diverse business users, and develop effective solutions.
• Experience producing standard and ad-hoc reports, performing advanced data mining, and generating accurate queries and outputs under tight deadlines.
• Ability to understand business requirements and regulatory needs and assess their impact on business operations and EDME.
• Experience maintaining comprehensive code documentation and developing business and system documentation in accordance with EOHHS standards and policies.
• Strong initiative and problem-solving skills, with the ability to independently research issues, identify solutions, and improve processes.
• Ability to quickly learn new technologies, tools, systems, data sources, and business processes with minimal guidance.
• Ability to manage competing priorities, adapt to changing demands, and meet deadlines in a fast-paced environment.

Pre-Offer Process\:

A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit http\://www.mass.gov/hhs/cori.

Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines.

Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the Commonwealth’s website.

ADA Reasonable Accommodation\: If you require a reasonable accommodation with the application/interview process, please contact us at\: EOHHS Candidate ADA Requests

For questions, please the contact the Office of Human Resources at 1-800-510-4122 and select option #4.

First consideration will be given to those applicants that apply within the first 14 days.

Minimum Entrance Requirements\: 

Applicants must have (A) at least two (2) years of full-time or equivalent part-time professional or practical experience in the field of information technology application development and support, or (B) any equivalent combination of the required experience and the substitutions below.

Substitutions\: 

I.  An Associate’s degree in a related field may substitute for one (1) year of the required experience.

II. A Bachelor’s degree or higher in a related field may substitute for the required experience.

Salary placement is determined by a combination of factors, including the candidate’s years of directly related experience and education, and alignment with our internal compensation structure as set forth by the Human Resources Division’s Hiring Guidelines. For all bargaining unit positions (non-management), compensation is subject to the salary provisions outlined in the applicable collective bargaining agreement and will apply to placement within the appropriate salary range.

Comprehensive Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

Want the specifics? Explore our Employee Benefits and Rewards!

An Equal Opportunity / Affirmative Action Employer.  Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.  Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements.  We encourage individuals who believe they have the skills necessary to thrive to apply for this role.

First consideration will be given to those applicants that apply within the first 14 days.

Minimum Entrance Requirements\: 

Applicants must have (A) at least two (2) years of full-time or equivalent part-time professional or practical experience in the field of information technology application development and support, or (B) any equivalent combination of the required experience and the substitutions below.

Substitutions\: 

I.  An Associate’s degree in a related field may substitute for one (1) year of the required experience.

II. A Bachelor’s degree or higher in a related field may substitute for the required experience.

Salary placement is determined by a combination of factors, including the candidate’s years of directly related experience and education, and alignment with our internal compensation structure as set forth by the Human Resources Division’s Hiring Guidelines. For all bargaining unit positions (non-management), compensation is subject to the salary provisions outlined in the applicable collective bargaining agreement and will apply to placement within the appropriate salary range.

Comprehensive Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

Want the specifics? Explore our Employee Benefits and Rewards!

An Equal Opportunity / Affirmative Action Employer.  Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.  Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements.  We encourage individuals who believe they have the skills necessary to thrive to apply for this role.

Tell us about a friend who might be interested in this job.All privacy rights will be protected.

Apply for a Job
Apply for a Job for JAWS Users
Create a Profile
System Requirements